﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace Tzx.Tools.Payroll2Images.Exe.TableToReport
{
    class DemoData
    {

        #region 示例数据

        Random r = new Random();

        public DataTable CreateTable()
        {
            DataTable table = new DataTable();

            #region header
            table.Columns.Add("ID", typeof(int));
            table.Columns.Add("中文名", typeof(string));
            table.Columns.Add("英文名", typeof(string));
            table.Columns.Add("工号", typeof(string));
            table.Columns.Add("年度", typeof(string));
            table.Columns.Add("月度", typeof(string));
            table.Columns.Add("金额", typeof(decimal));
            table.Columns.Add("备注", typeof(string));

            #endregion

            #region rows
            for (int i = 1; i < 10; i++)
            {
                DataRow dr = table.NewRow();
                dr["ID"] = 1000 + i;
                dr["中文名"] = "李张刘王吴陈纪唐石钟".ToCharArray()[r.Next(0, 10)] + GetRandomChinese(2);
                dr["英文名"] = string.Format("{0}{1}{2}",
                        (char)r.Next('a', 'z' + 1),
                        (char)r.Next('a', 'z' + 1),
                        (char)r.Next('a', 'z' + 1)
                        );
                dr["工号"] = "00" + i + "0" + i;
                dr["年度"] = r.Next(2013, DateTime.Today.Year + 1);
                dr["月度"] = r.Next(1, 13);
                dr["金额"] = r.Next(3000, 8000) + Math.Round(r.NextDouble(), 1);
                dr["备注"] = "remark " + (char)r.Next('a', 'z' + 1);

                //
                table.Rows.Add(dr);
            }
            #endregion

            return table;
        }

        #region 随机汉字

        /// <summary>
        /// 
        /// </summary>
        /// <param name="strlength"></param>
        /// <returns></returns>
        public string GetRandomChinese(int strlength)
        {
            // 获取GB2312编码页（表） 
            Encoding gb = Encoding.GetEncoding("gb2312");
            object[] bytes = CreateRegionCode(strlength);
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < strlength; i++)
            {
                string temp = gb.GetString((byte[])Convert.ChangeType(bytes[i], typeof(byte[])));
                sb.Append(temp);
            }
            return sb.ToString();
        }

        //此函数在汉字编码范围内随机创建含两个元素的十六进制字节数组，每个字节数组代表一个汉字，并将 
        //四个字节数组存储在object数组中。 
        //参数：strlength，代表需要产生的汉字个数 

        Random rnd = new Random();

        /// <summary>
        /// 
        /// </summary>
        /// <param name="strlength"></param>
        /// <returns></returns>
        private object[] CreateRegionCode(int strlength)
        {
            //定义一个字符串数组储存汉字编码的组成元素 
            string[] rBase = new String[16] { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f" };



            //定义一个object数组用来 
            object[] bytes = new object[strlength];

            /**
             每循环一次产生一个含两个元素的十六进制字节数组，并将其放入bytes数组中 
             每个汉字有四个区位码组成 
             区位码第1位和区位码第2位作为字节数组第一个元素 
             区位码第3位和区位码第4位作为字节数组第二个元素 
            **/
            for (int i = 0; i < strlength; i++)
            {
                //
                System.Threading.Thread.Sleep(4);

                //区位码第1位 
                int r1 = rnd.Next(11, 14);
                string str_r1 = rBase[r1].Trim();

                //区位码第2位 
                rnd = new Random(r1 * unchecked((int)DateTime.Now.Ticks) + i); // 更换随机数发生器的 种子避免产生重复值 
                int r2;
                if (r1 == 13)
                {
                    r2 = rnd.Next(0, 7);
                }
                else
                {
                    r2 = rnd.Next(0, 16);
                }
                string str_r2 = rBase[r2].Trim();

                //区位码第3位 
                rnd = new Random(r2 * unchecked((int)DateTime.Now.Ticks) + i);
                int r3 = rnd.Next(10, 16);
                string str_r3 = rBase[r3].Trim();

                //区位码第4位 
                rnd = new Random(r3 * unchecked((int)DateTime.Now.Ticks) + i);
                int r4;
                if (r3 == 10)
                {
                    r4 = rnd.Next(1, 16);
                }
                else if (r3 == 15)
                {
                    r4 = rnd.Next(0, 15);
                }
                else
                {
                    r4 = rnd.Next(0, 16);
                }
                string str_r4 = rBase[r4].Trim();

                // 定义两个字节变量存储产生的随机汉字区位码 
                byte byte1 = Convert.ToByte(str_r1 + str_r2, 16);
                byte byte2 = Convert.ToByte(str_r3 + str_r4, 16);
                // 将两个字节变量存储在字节数组中 
                byte[] str_r = new byte[] { byte1, byte2 };

                // 将产生的一个汉字的字节数组放入object数组中 
                bytes.SetValue(str_r, i);
            }

            return bytes;
        }

        #endregion

        private string TableToString(DataTable table)
        {
            StringBuilder sb = new StringBuilder();
            int colCount = table.Columns.Count;
            for (int idx = 0; idx < colCount; idx++)
            {
                sb.Append(table.Columns[idx].ColumnName + "\t");
            }
            sb.AppendLine("\n----------------------------------------------------------------------");

            foreach (DataRow dr in table.Rows)
            {
                for (int idx = 0; idx < colCount; idx++)
                {
                    sb.Append(dr[idx] + "\t");
                }//for
                sb.AppendLine();
            }//foreach

            return sb.ToString();
        }


        #endregion


    }
}
